Table of Contents

Purpose
Procedure for using the Return Preparation Utility (RPU)
Instructions for using the Return Preparation Utility (RPU)
Nil Statement
Saving of Intermediate File
Generation of .fvu file
Submission of statement
Windows Short Cut Keys

1. Purpose

This utility can be used for preparing statements for Form24Q, 26Q, 27Q, 27EQ (regular & correction) for all quarters of F.Y. 2005-06 and onwards.

2. Procedure for using the Return Preparation Utility (RPU)

• Select type of statement to be prepared, i.e. regular or correction.
  
• Preparation of Regular statement: Select 'Regular' thereafter click on 'Click to continue'.
  
• Preparation of Correction statements: Select 'Correction' thereafter click on 'Import Regular file to be corrected'. Browse and select regular file to be corrected (.fvu file).
  
• Only regular statements that have been accepted in TIN central system can be corrected.
  
• On successful import a dialogue box will open. Enter 15-digit provisional receipt number (PRN) of regular statement imported and click on 'Prepare Correction Statement'.
  
• Thereafter carry out corrections in regular statement.
  

3. Instructions for using the Return Preparation Utility (RPU)

• Fields marked by asterisks (*) are mandatory.
  
• Date: Date to be entered in DD/MM/YYYY format (e.g. 31/03/2006). Date can be selected from Year Box provided in respective cells. Double click in that particular cell to select date.
  
• Insert Rows: To insert rows click on "Insert Row" button. Enter number of rows to be inserted.
  
• Delete Rows: To delete rows click on "Delete Row" button. In Challan Sheet, only last row can be deleted.
  
• If drop down list has been provided for any field, then value should be picked from given list only.
  
• Amount field should not be left blank. Enter “0” (zero) if no amount is to be mentioned in any of the amount fields.
  
• Amount must be greater than ‘0’ (zero) in the total amount paid/credited field in annexure I.
  
• PAN/TAN should be entered in Capital Letters only (e.g. MUMN05226E).
  

4. Nil Statement

If there is no deductee/party, then Annexure I should be left blank.

5.Saving of Intermediate File:

To save intermediate file, click on "Save" button. It will ask for path and name by which file has to be saved. After saving file, do not change its name and path. Note that hidden files with .ss3 extension are also saved at the same location where original file is saved. To unhide these file go to "Tools -> View -> Hidden files and folders" and click on "Show hidden files and folder". In case of 24Q4 only three hidden files will be created else two files will be created.

Example:

6. Generation of .fvu file

FVU is inbuilt in this RPU. After preparation of statement (data is filled in all sheets) click on 'create file'. It will ask the location at which the file is to be saved and following files will be created.

File is correct:

• .fvu file (fvu file should be copied on a CD/floppy)
• .txt file
• FVU -TDS statement statistics report (to be used in preparing Form 27A)
• TDS/TCS-PAN statistics (created if PAN of the deductee is PANNOTAVBL, PANAPPLIED, PANINVALID)

• .txt file
• Error file (both in .txt and html)

7. Submission of statement

If statement is being filed through a TIN-FC, then CD/floppy should be accompanied by 'Statement Statistics Report' generated by the FVU along with Form 27A in physical form. Form 27A should be prepared separately. Format of same is available at www.tin-nsdl.com. The control totals on Form 27A and Statement Statistics Report should match with the statement details.

User can directly upload the statement to NSDL through online upload facility.

8. Windows Short Cut Keys

Caution :

It may be noted this RPU has been provided with a view to help deductors in preparation of their TDS statements. While all necessary care has been taken by NSDL, deductors are advised to ensure the correctness of their statement in all respects, including but not limited to its conformity with the applicable rules before the submission of same. NSDL does not assume any responsibility in respect of performance or output of the RPU in any manner. It should be noted that RPU and FVU are subject to modifications by NSDL. Hence the latest available version on our website should be used.